Quartiles

Excel Cheat Sheet


Use the following code to calculate the different quartiles:

Q1 (first Quartile):

=QUARTILE.EXC([DATA SET],1)

Q2 (second Quartile or Median):

=QUARTILE.EXC([DATA SET],2)

Q3: (third Quartile):

=QUARTILE.EXC([DATA SET],3)